123456/PO PHP H5/Ifra - Nisrine/filmdetails.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
<link rel="stylesheet" href="style/style.css">
</head>
<body>
<div class="menubalk">
<a border="10" href="studio.php">studio's</a>
<a href="film.php">films</a>
<a href="characters.php">characters</a>
<a href="personen.php">personen</a>
</div>
<?php
include("db.php");
$flid = $_GET['filmid'];
$query = "select * from films
where filmid=$flid";
$result = mysqli_query($db, $query);
$row = mysqli_fetch_array($result);
echo "<h1>$row[titel]</h1>";
echo "<div><p> het is uigebracht in het jaar $row[release_date]</p></div>";
echo "<p>genre: $row[genre]</p>";
$query= "select * from films f, characters c
where c.filmid=f.filmid and f.filmid=$flid";
$result = mysqli_query($db, $query);
while ($row = mysqli_fetch_array($result)){
echo "<p>characters in $row[titel]</p>";
echo "<div><a href='characterdetails.php?characterid=$row[characterid]'>$row[naam_character]</a></div>";
}
$query= "select * from films f, acteurs a
where a.persoonid = f.persoonid and f.filmid=$flid";
$result = mysqli_query($db, $query);
while ($row = mysqli_fetch_array($result)){
echo "<p>regisseur:</p> <a href='regiseurdetails.php?persoonid=$row[persoonid]'>$row[voornaam] $row[achternaam]</a>";
}
$query = "select * from studio u, films f
where f.studioid = u.studioid and f.filmid = $flid";
$result = mysqli_query($db, $query);
$row = mysqli_fetch_array($result);
echo "<div><p>gemaakst door studio</p></div>";
echo "<div><a href='studiodetails.php?studioid=$row[studioid]'>$row[naam]</a></div>";
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse